<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1">
  <title id="af20941">DROP COLLATION</title>
  <body>
    <p id="sql_command_desc">Removes a previously defined collation. </p>
    <section id="section2">
      <title>Synopsis</title>
      <codeblock id="sql_command_synopsis">DROP COLLATION [ IF EXISTS ] <varname>name</varname> [ CASCADE | RESTRICT ]</codeblock>
    </section>
    <section id="section4">
      <title>Parameters</title>
      <parml>
        <plentry>
          <pt><codeph>IF EXISTS</codeph></pt>
          <pd> Do not throw an error if the collation does not exist. A notice is issued in this
            case. </pd>
        </plentry>
        <plentry>
          <pt><varname>name</varname></pt>
          <pd> The name of the collation. The collation name can be schema-qualified. </pd>
        </plentry>
        <plentry>
          <pt><codeph>CASCADE</codeph></pt>
          <pd> Automatically drop objects that depend on the collation. </pd>
        </plentry>
        <plentry>
          <pt><codeph>RESTRICT</codeph></pt>
          <pd> Refuse to drop the collation if any objects depend on it. This is the default. </pd>
        </plentry>
      </parml>
    </section>
    <section id="section5">
      <title>Notes</title>
      <p>
        <codeph>DROP COLLATION</codeph> removes a previously defined collation. To be able to drop a
        collation, you must own the collation.</p>
    </section>
    <section id="section6">
      <title>Examples</title>
      <p> To drop the collation named <codeph>german</codeph>:
        <codeblock>DROP COLLATION german;</codeblock>
      </p>
    </section>
    <section id="section7">
      <title>Compatibility</title>
      <p> The <codeph>DROP COLLATION</codeph> command conforms to the SQL standard, apart from the
          <codeph>IF EXISTS</codeph> option, which is a Greenplum Database extension. </p>
    </section>
    <section id="section8">
      <title>See Also</title>
      <p>
        <codeph>
          <xref href="./ALTER_COLLATION.xml#topic1" type="topic" format="dita"/></codeph>,
            <codeph><xref href="./CREATE_COLLATION.xml#topic1" type="topic" format="dita"/>
        </codeph>
      </p>
    </section>
  </body>
</topic>
